﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MainSite.Master" AutoEventWireup="true" CodeBehind="EmployeesReport.aspx.cs" Inherits="BSCMFF.Web.Pages.Reporting.EmployeesReport" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" 
    AllowSorting="True" CellSpacing="0" GridLines="None">
</telerik:RadGrid>

<telerik:RadGrid ID="RadGrid2" runat="server" AllowFilteringByColumn="True" AutoGenerateColumns="false"
    AllowSorting="True" CellSpacing="0" GridLines="None"
    ShowGroupPanel="false" >
    <GroupingSettings RetainGroupFootersVisibility="true" />
    <MasterTableView GroupLoadMode="Client" ShowGroupFooter="true">
        <GroupByExpressions>
            <telerik:GridGroupByExpression>
                <SelectFields>
                    <telerik:GridGroupByField FieldAlias="Employee" FieldName="first" 
                        HeaderValueSeparator=" : "></telerik:GridGroupByField>
                </SelectFields>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="empID" ></telerik:GridGroupByField>
                </GroupByFields>
            </telerik:GridGroupByExpression>
        </GroupByExpressions>
        
        <Columns>
            <telerik:GridBoundColumn DataField="empID" DataType="System.Int32" Visible="false"
                HeaderText="Emp ID"
                FilterControlAltText="Filter empID column" UniqueName="empID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="first" HeaderText="Firstname"
                FilterControlAltText="Filter Firstname column" UniqueName="Firstname">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="last" HeaderText="Lastname"
                FilterControlAltText="Filter Lastname column" UniqueName="Lastname">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn Aggregate="Sum" FooterText="Total Weight: " 
                DataField="weight" DataType="System.Int32" HeaderText="Weight"
                FilterControlAltText="Filter weight column" UniqueName="weight">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn Aggregate="Sum" FooterText="Total Score: " 
                DataField="score" DataType="System.Int32" HeaderText="Score"
                FilterControlAltText="Filter score column" UniqueName="score">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn Aggregate="Sum" FooterText="Total Weighted Score: " 
                DataField="weightedScore" DataType="System.Int32" HeaderText="Weighted Score"
                FilterControlAltText="Filter weightedScore column" UniqueName="weightedScore">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="verbal" DataType="System.String" HeaderText="Verbal Evaluation"
                FilterControlAltText="Filter verbal column" UniqueName="verbal">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
</asp:Content>
